SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395311 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395311 [ RunTime:0.007676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915904,605890,186636,55396,930846,960790,188439,522522,57707,278683,741844,920566,633329,79486,500426,826728,1025210,703637,459972,43809,399946,468779,899640,810581,582064,593444,151994,453318,697380,926269,518959,237607,950399,64232,162805,298474,940215,937129,908234,532099,293597,259683,110258,304379,112601,1008344,136782,363967,6742,233431,671220,865547,242177,596810,608803,608265,470165,385902,898107,848885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]