SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505269 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505269 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499748,743696,830489,149824,435462,186931,252122,171636,867879,1018481,990240,276034,329832,196940,610957,974043,116629,506600,411032,729880,846875,767420,630066,907828,713111,601842,651588,3,369366,988582,57897,648655,979867,456481,1040999,783681,822428,109436,438564,886958,922931,720410,243555,973390,642664,684639,128723,387733,234267,322584,319605,1003151,717104,14663,220910,142863,754679,416373,372872,388695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000850s ]