SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531316 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531316 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49990,232199,891920,726508,369956,827661,191863,323134,671042,1013124,431568,273317,20576,417904,799355,759852,210270,10941,249908,64508,988868,26704,916484,797058,204688,156088,725587,867205,545313,1029039,881664,235604,495435,1028642,663436,493932,788498,1026260,275078,937205,298959,271827,618909,609339,310358,91431,1028267,210768,1031245,470339,96672,76586,765429,853788,393545,714457,581977,124700,23353,667914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]