SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52711 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52711 [ RunTime:0.004006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439765,986301,323590,729593,464833,597160,553238,415792,973647,134616,1039395,80782,677346,267079,719963,807604,938270,223537,363893,968011,80200,314964,500176,1039943,497788,1023341,322424,136619,249928,280828,27592,352548,155350,927882,520907,195169,439085,390079,373765,113347,39557,758707,370781,579186,431336,816026,487506,592226,433049,669414,83105,786096,809472,946589,1036140,842016,727389,733429,135613,251741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]