SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193393 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193393 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331753,503685,934957,508000,280978,604596,100966,529219,391020,610918,779200,1043263,16267,898835,839451,300690,379374,1034282,821914,794501,609504,87732,532287,976131,373316,756755,866279,655755,682403,588255,354128,600534,698901,179113,268176,99344,296673,539333,132188,403399,380975,93576,291092,1035720,228843,528953,914682,347779,530334,382677,32172,430373,683858,789799,866483,545688,215488,37779,187171,980040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]