SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 956896 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 956896 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930713,643080,962488,849810,90055,402527,202593,315922,359156,201247,428318,928878,531926,213823,964389,131216,1003864,722341,431293,798600,552868,27915,310278,502621,353502,602679,38199,991146,1034961,326383,779344,810631,148707,307740,624698,175789,246254,681388,267427,140084,478117,316931,899020,1039333,231933,293549,138622,704743,672382,249893,28721,588662,340794,403690,441342,448299,404435,435408,31534,295762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 956896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 956896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]