SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 157823 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 157823 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110185,10974,315836,55832,752071,982976,881915,94080,1019788,444849,647987,901010,711091,338856,1014079,408019,603131,107542,970547,924099,474043,546292,285120,550673,117996,465251,51832,170769,1018076,467520,77567,998954,502415,400068,491147,978282,293694,898231,356217,795549,102896,386488,96750,122764,54508,558505,473893,206202,736538,936128,395709,651591,311422,1037471,111073,246784,963583,501896,273325,307813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 157823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 157823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001120s ]