SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402849 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402849 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028556,165476,573662,273340,348809,32494,343068,521982,463504,1029460,965354,579036,86474,54141,795761,874987,437397,486076,554254,99387,132656,1013659,738573,1006719,395684,442156,728977,58037,203226,399071,44301,609820,683078,594901,178648,1017455,370180,751022,835671,266637,224655,835854,349557,683774,195078,175545,1046589,452667,422451,644696,924367,20122,141968,694778,882286,609710,846270,773015,944210,498088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402849 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402849 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]