SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031068 LIMIT 1 [ RunTime:0.002639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031068 [ RunTime:0.003413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598498,393097,828828,477755,129358,140672,449401,836868,425045,916016,645444,337134,243146,992004,651382,38188,354333,309601,440834,815205,694619,997815,904897,151085,353779,729119,359824,937212,32438,76592,658143,130487,15919,660651,21740,795915,535706,106120,729678,964463,419730,449016,177872,315278,289045,235916,420283,306620,218634,115193,601825,769277,829197,457385,706806,94561,107128,851242,658221,955024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000760s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]