SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408142 LIMIT 1 [ RunTime:0.001262s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408142 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4801,226977,1021247,565195,562185,260105,829990,755359,514819,570514,228496,64303,971817,799680,579379,870708,825298,828921,485112,285648,810756,236478,483972,935231,744119,422513,1040118,983675,736247,912112,42999,725011,999133,1041764,416983,213492,732839,936980,826964,120035,16296,996097,264076,755850,344810,611903,326667,704294,32578,487698,461956,284386,195034,501413,611933,748528,173920,1044473,460200,293492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002059s ]