SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505140 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505140 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042729,46872,368369,916026,83124,467492,61904,80501,615367,490947,697730,3565,528749,420382,464899,32269,71911,795289,191605,414744,66949,461588,532918,583654,514965,784596,294287,452827,373340,286008,702031,592948,259349,89770,800977,883964,431500,469672,1040878,716538,122438,920241,607807,492047,121583,325205,87987,1002585,762453,966257,831718,5168,999444,582674,12124,445570,821621,800637,291446,770085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]