SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014102 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014102 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768945,101696,274713,617903,270626,517994,764098,34018,501076,674315,981723,453698,487267,809722,303858,68071,358837,300369,675518,497864,414194,196488,903121,790420,174290,662337,796846,233992,322288,150385,801816,996938,931899,604580,586293,68140,488819,425208,204659,860974,1047618,906753,862182,836823,644177,791540,278650,168385,1027347,18224,605979,642807,907293,46936,486637,407399,620076,962766,294375,420203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]