SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041395 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041395 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187044,379107,90920,526105,780347,1004218,674500,433448,72290,23846,543742,858852,72311,670489,11157,930795,869660,560156,112974,877987,225338,504496,768885,44499,862049,538685,792682,387138,558770,706586,267751,581651,609438,477108,65015,620132,54508,348368,346728,618083,727419,814454,328798,947717,363818,8152,264702,651682,265448,196898,53241,768169,702358,49743,80808,562811,856277,619278,703917,159611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]