SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684045 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684045 [ RunTime:0.002273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156358,48978,507699,147864,896600,246382,925209,161583,774255,298110,347700,974914,1037644,212398,877126,772515,947227,828983,229452,738520,462210,928552,858824,465229,839141,295920,257569,609393,298422,939987,561034,925049,965921,805705,958258,198537,151212,818779,156594,47542,691204,886396,88883,1036513,332691,1036195,841755,791601,904619,644451,468242,90391,166200,253723,1029172,540190,1006251,151350,333358,703414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]