SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 740315 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 740315 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750023,654053,526462,486980,587009,110526,955192,1022641,302586,339146,831903,342066,150908,462592,435293,955702,586677,961782,251388,1015094,411102,763852,650655,990779,1043321,940827,761651,189409,730247,388612,279226,85511,662704,325690,573315,681572,285763,374734,454124,823441,965356,930100,544988,1015619,603866,701797,172268,88087,109619,1028456,247273,874275,193190,887466,20693,366732,361118,750010,300923,332829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 740315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 740315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]