SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503427 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503427 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048740,829035,757976,770928,31053,794894,645566,245765,998310,74886,228770,428402,73466,125206,244678,574176,1043840,107455,444263,702538,307181,764823,88140,800336,412084,406044,897816,820652,562414,830557,329777,356304,989147,515458,694890,285964,84996,821733,631706,881931,796382,985397,719219,236323,577773,151736,9465,497447,846503,996938,825785,528198,455286,180965,604744,87541,632391,928290,392778,494640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]