SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578041 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578041 [ RunTime:0.002658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599079,661118,566912,900434,939298,883134,632571,1026682,131040,1039574,440885,386795,701521,871794,755200,425244,718882,725985,945201,262072,29943,853853,440229,633036,1027515,46102,362478,1000920,255989,664185,712834,771560,981443,428250,761048,538616,270546,934692,647629,725794,537589,540459,439176,997145,181791,151000,482208,711921,448217,365953,1006861,269466,26298,24254,136837,202099,235359,849400,808598,174761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]