SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 674198 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 674198 [ RunTime:0.005148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150322,1013378,64827,830308,784345,46156,475781,73492,270683,154275,1009842,707501,908702,903235,225599,498113,935803,215664,727102,342005,741767,994384,136027,257751,542252,1032906,48842,416214,544603,541704,457101,101808,481381,870387,280902,411007,707813,902650,421380,967661,850680,981898,310844,394668,177311,197068,962224,522632,201074,96647,985196,406866,1007385,302266,185194,190398,279742,94498,248934,584135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 674198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 674198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]