SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253313 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253313 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773094,719836,671645,140401,796503,85006,656583,843156,300001,952443,980505,129455,664530,49300,772190,918804,353476,854792,468947,94090,824759,190287,711700,463047,352563,599613,673101,891296,104808,125536,791643,932605,852370,459132,679407,331849,586312,796798,1042571,781940,563940,21325,948956,800985,138959,1036713,826129,56677,1013192,563767,146179,339312,747833,782855,605225,396635,679258,1044278,422550,813452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]