SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496252 LIMIT 1 [ RunTime:0.000706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496252 [ RunTime:0.004604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954332,1032522,973621,151371,811686,478863,268124,1001870,134969,216897,1018543,751474,728715,417738,779315,127923,238859,130464,541363,822221,168178,982057,951754,713165,241674,240620,910645,546074,95034,109235,977330,147689,578529,783463,38689,49870,880378,867904,333004,1037472,463060,521864,114867,219506,565852,395393,899068,479414,394050,684056,683834,906230,1040566,406909,22978,300578,14567,439386,396174,203856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]