SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001591s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367203 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367203 [ RunTime:0.003470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531681,48638,622431,67146,432080,851051,681082,577526,727711,637100,94030,673990,651868,359325,928961,369303,961896,270517,570396,721174,360500,1010872,947961,88849,228224,710112,90890,923380,435447,106797,31596,151610,638540,812141,329943,380862,870515,341607,64989,724284,531762,231681,884949,54239,373298,299823,76675,866656,341193,459121,766855,760059,872859,93825,784350,736556,870346,382309,263763,408674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]