SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560912 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560912 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123396,253498,199649,738970,53657,557327,430451,70852,515393,108266,789146,262873,839642,216835,918636,554140,142034,397512,496944,84190,329075,817672,627743,490744,352414,392190,366544,189635,329379,139107,423860,692339,122144,451181,391201,619219,503260,785818,957508,262188,326803,681298,963522,591836,424196,277473,293567,643000,673749,344033,269496,130697,603456,219196,51604,737730,280533,208424,240332,769217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]