SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538023 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538023 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690195,668658,654159,642153,887464,565397,467376,699125,955668,206606,20496,123079,790927,392452,117358,301709,913256,939037,649978,33250,187470,155020,811317,836328,37271,430974,889495,953935,321888,558641,404681,923654,90579,169519,400557,354109,946042,672801,18419,1048749,955588,324571,287487,558763,790897,469069,137695,337770,641422,341052,526410,648491,366287,134557,180095,803356,116531,487720,590471,718139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]