SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042209 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042209 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91042,119559,390124,440721,175933,582713,202268,655941,176852,690653,896449,1017159,80534,44388,626008,972217,1025024,975455,612106,970060,732927,793110,672797,138650,178944,318760,625317,68832,337587,785575,28331,129369,777042,823516,768529,617777,939534,561898,687290,968354,619758,631224,583672,188790,635533,345064,603175,337383,502699,210768,182095,276210,50525,655125,37539,281093,255283,631317,413550,514193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]