SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002935s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040194 LIMIT 1 [ RunTime:0.000759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040194 [ RunTime:0.004438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778079,893032,148594,620937,564241,42600,644675,511834,217719,251947,248974,1045579,1024460,574077,922868,844982,552366,784260,281554,469059,849172,721653,88544,349337,369712,780198,576955,196237,417073,420126,138773,82072,283988,341010,746218,500933,1017464,461148,237097,156193,918953,31986,443471,377867,177270,730176,280707,580608,703951,647670,391441,310316,534370,392345,554857,85934,1018371,1044639,418538,614271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002460s ]