SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001215 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001215 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837015,931157,650371,281766,695287,188732,650521,512776,1041920,639849,134665,1029776,831394,902342,927336,230781,51168,406736,213606,535561,375030,389890,840480,984997,505253,1031650,100080,948245,71759,734060,813782,924572,602377,89830,584314,874099,131683,858919,1035413,177721,116068,679004,217452,977686,114918,137064,142863,52389,504072,642556,265175,382686,726794,526469,634458,519812,594947,213985,495370,164801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]