SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005163 LIMIT 1 [ RunTime:0.001161s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005163 [ RunTime:0.003840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12225,712130,50612,932011,768170,439158,128024,879056,39305,394361,530613,290863,196889,632066,221544,547712,996500,641584,921658,319211,905185,34911,652862,265237,466536,887804,741422,414539,82977,992656,525696,1031528,344927,570283,81347,454230,512349,879769,597270,562643,884058,197048,161794,16109,660658,713080,429170,632428,1001478,406396,269995,4164,577467,366182,516094,561539,101114,357480,548790,337628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]