SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531739 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531739 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526457,246759,857804,121056,773352,698735,249253,882238,334515,276555,812984,350976,575505,1001179,434316,334516,660059,1015046,303366,420920,620493,19483,349753,429022,244397,940542,649014,101373,174675,34454,966434,428752,1029045,427540,713521,857538,897152,593577,667384,152677,334165,165365,244103,709162,779058,130400,687551,373870,449504,97090,755550,1038167,744504,468011,1029164,24107,531515,837817,786660,903530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]