SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311160 LIMIT 1 [ RunTime:0.000875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311160 [ RunTime:0.002838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216160,585832,932829,821487,548097,340369,647489,214483,812863,112888,262909,674975,501209,229762,96934,91485,92822,479889,656761,709838,271682,202253,403349,405979,493394,865164,796418,127621,957606,397611,784680,925721,389127,936731,1028099,141975,909059,688075,777716,219083,914209,540088,492824,388269,559763,69479,6480,819460,746343,514517,771674,51399,480509,146955,953065,398623,839483,91510,832740,359821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001312s ]