SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983004 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983004 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532578,863184,12893,518251,173688,60060,1029372,18012,674752,431850,725418,737957,923806,785193,590108,64851,907796,101291,714825,515675,858687,48399,339047,419108,819213,452395,562501,1011584,134200,399302,440651,932105,366852,1028059,141911,229,910768,469572,313954,237653,951786,591099,293276,560844,1026504,1036159,188243,881079,849505,817269,868428,359633,685545,800915,328216,299614,609371,318810,248906,982594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]