SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454699 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454699 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530024,575426,205094,684817,440623,845489,773560,826680,591999,28890,285580,342969,530420,57633,482915,603159,464,430594,751363,1022315,565,256618,42249,1006542,1017854,181886,480915,674911,370613,848331,624961,475774,937387,614373,119792,1018261,807960,1009490,719451,547014,877222,350965,258820,629196,723661,1029955,560586,730328,561538,961757,265429,503704,127954,861576,571101,420581,137522,277404,738732,943861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]