SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306823 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306823 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235677,1030849,490975,36944,1040607,551863,500661,621755,953230,428550,76505,930869,997409,539564,67260,790118,80855,384373,367938,896559,338504,1042482,931814,561443,265684,816343,539339,492047,761096,690850,102730,535394,542872,859972,669922,684321,959324,207279,910705,573769,831446,604030,101948,25233,915252,995499,270059,310988,632689,966527,723276,244953,784286,525452,349933,781908,842889,533776,576036,362111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]