SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104193 LIMIT 1 [ RunTime:0.001933s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104193 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422885,37886,708179,405668,470441,909871,826863,341386,588204,26534,685750,703546,1009141,558117,714950,598560,493137,304091,31332,176566,127952,391842,442750,81656,528007,223059,161938,611961,424119,106196,621609,325683,535080,519578,874296,1027194,458665,129680,140700,966696,11173,438785,936499,923634,1003998,740091,366870,843102,966682,311911,735130,768820,738119,143999,1040438,925062,301451,301191,878691,863672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.012293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006435s ]