SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538243 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538243 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359445,1048681,810890,304036,807681,715104,90105,532237,72673,852432,445079,577341,343974,976466,98845,596563,196917,962478,852427,324625,340721,940208,680319,794744,368011,719523,204338,177207,982703,844571,1012458,657237,373468,426331,564011,376252,258951,332892,477804,291146,575661,637478,348931,585955,691775,652913,657927,337814,402092,106689,587665,791460,701414,403448,344033,510507,281445,166640,167724,862475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000956s ]