SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142160 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142160 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415010,980570,796509,7845,997785,553891,1003685,765815,418940,796464,901392,486028,611291,1031177,336562,583859,1025805,339216,262346,911715,879179,308461,448861,1006461,517094,223938,562777,711540,726420,976068,458385,279674,1047081,574244,571777,715236,225869,187371,226082,838203,539422,696745,741086,134462,114587,353239,555750,714134,779648,827376,328259,959468,123844,340366,395229,732795,354055,376450,423094,589114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]