SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597915 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597915 [ RunTime:0.002784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400818,291656,539117,240836,934050,769883,116447,1014677,802085,782219,783704,708825,1034443,22033,67585,948785,876434,1031518,716518,759459,146430,266506,364777,726460,363720,762617,553414,843634,256643,539610,548513,890248,912278,991414,354244,147762,446833,197391,779387,294039,250261,547274,186154,956919,45767,272160,524378,587059,138163,673713,158834,428846,218239,144795,922017,346814,142442,751460,709558,373124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]