SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043418 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043418 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247865,188088,214579,919074,814245,133998,494862,314563,170412,166608,969631,602102,935499,902827,99730,271607,92249,726387,864529,772011,869443,450697,686665,839817,712755,578237,831735,162759,81856,15393,573267,962127,817639,160535,854878,659062,216733,575207,385614,515954,1047117,935880,59623,249235,146840,940689,846176,799233,917185,862915,71870,733950,462064,662729,901708,393765,242911,287450,548275,283752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]