SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550328 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550328 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764295,424386,617257,989624,1010328,820781,225892,1009563,1027204,372573,632225,363682,798364,848312,767061,938778,318752,1014338,583813,161854,511296,507509,911953,851646,307896,819102,854651,611782,348100,754701,904793,544527,938441,564845,1023076,196771,945032,60169,708824,813034,707086,319541,574078,895686,666635,608051,543057,147313,875528,91843,548123,478623,439323,894132,36397,777470,792812,435767,478989,902771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]