SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901988 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901988 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435775,705964,159659,739368,370509,395166,600071,83457,420710,160700,124949,462667,109424,335400,125655,966089,940094,713838,240440,590344,709604,981824,253917,1040518,113194,265768,982096,155048,107807,133536,451304,995104,806687,541842,25839,412603,185261,648414,684225,651548,515315,999060,605880,564372,1015731,312027,279946,708008,947330,962590,479765,995949,71480,488369,710358,594782,92084,28426,252613,702791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]